﻿using System;
using Microsoft.EntityFrameworkCore.Migrations;

#nullable disable

namespace TuLing.Service.Migrations
{
    public partial class Init : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.CreateTable(
                name: "Customers",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Name = table.Column<string>(type: "TEXT", nullable: false),
                    Phone = table.Column<string>(type: "TEXT", nullable: true),
                    Address = table.Column<string>(type: "TEXT", nullable: true),
                    Remark = table.Column<string>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Customers", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Finance",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Code = table.Column<string>(type: "TEXT", nullable: false),
                    CreatedAt = table.Column<DateTime>(type: "TEXT", nullable: false),
                    FormType = table.Column<int>(type: "INTEGER", nullable: false),
                    Amount = table.Column<decimal>(type: "TEXT", nullable: false),
                    Item = table.Column<string>(type: "TEXT", nullable: false),
                    Remark = table.Column<string>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Finance", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Permissions",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    UniqueCode = table.Column<string>(type: "TEXT", nullable: false),
                    UniqueName = table.Column<string>(type: "TEXT", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Permissions", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "ProductCategorys",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Code = table.Column<string>(type: "TEXT", nullable: false),
                    Name = table.Column<string>(type: "TEXT", nullable: false),
                    ParentId = table.Column<long>(type: "INTEGER", nullable: false),
                    ProductCategoryId = table.Column<long>(type: "INTEGER", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_ProductCategorys", x => x.Id);
                    table.ForeignKey(
                        name: "FK_ProductCategorys_ProductCategorys_ProductCategoryId",
                        column: x => x.ProductCategoryId,
                        principalTable: "ProductCategorys",
                        principalColumn: "Id");
                });

            migrationBuilder.CreateTable(
                name: "Roles",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Name = table.Column<string>(type: "TEXT", nullable: false),
                    Remark = table.Column<string>(type: "TEXT", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Roles", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Suppliers",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Name = table.Column<string>(type: "TEXT", nullable: false),
                    Phone = table.Column<string>(type: "TEXT", nullable: true),
                    Address = table.Column<string>(type: "TEXT", nullable: true),
                    Balance = table.Column<decimal>(type: "TEXT", nullable: false),
                    Remark = table.Column<string>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Suppliers", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Units",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Name = table.Column<string>(type: "TEXT", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Units", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Users",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Account = table.Column<string>(type: "TEXT", nullable: false),
                    Password = table.Column<string>(type: "TEXT", nullable: false),
                    Name = table.Column<string>(type: "TEXT", nullable: false),
                    Phone = table.Column<string>(type: "TEXT", nullable: false),
                    Remark = table.Column<string>(type: "TEXT", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Users", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "SaleOrderReturns",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Code = table.Column<string>(type: "TEXT", nullable: false),
                    Name = table.Column<string>(type: "TEXT", nullable: false),
                    Remark = table.Column<string>(type: "TEXT", nullable: true),
                    CreatedAt = table.Column<DateTime>(type: "TEXT", nullable: false),
                    CustomerId = table.Column<long>(type: "INTEGER", nullable: false),
                    BuyOrderId = table.Column<long>(type: "INTEGER", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_SaleOrderReturns", x => x.Id);
                    table.ForeignKey(
                        name: "FK_SaleOrderReturns_Customers_CustomerId",
                        column: x => x.CustomerId,
                        principalTable: "Customers",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "SaleOrders",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Code = table.Column<string>(type: "TEXT", nullable: false),
                    Name = table.Column<string>(type: "TEXT", nullable: false),
                    CreatedAt = table.Column<DateTime>(type: "TEXT", nullable: false),
                    CustomerId = table.Column<long>(type: "INTEGER", nullable: false),
                    Remark = table.Column<string>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_SaleOrders", x => x.Id);
                    table.ForeignKey(
                        name: "FK_SaleOrders_Customers_CustomerId",
                        column: x => x.CustomerId,
                        principalTable: "Customers",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "Products",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    ProductCategoryId = table.Column<long>(type: "INTEGER", nullable: false),
                    Code = table.Column<string>(type: "TEXT", nullable: false),
                    Name = table.Column<string>(type: "TEXT", nullable: false),
                    Unit = table.Column<string>(type: "TEXT", nullable: false),
                    Price = table.Column<decimal>(type: "TEXT", nullable: false),
                    Remark = table.Column<string>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Products", x => x.Id);
                    table.ForeignKey(
                        name: "FK_Products_ProductCategorys_ProductCategoryId",
                        column: x => x.ProductCategoryId,
                        principalTable: "ProductCategorys",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "RolePermissions",
                columns: table => new
                {
                    RoleId = table.Column<long>(type: "INTEGER", nullable: false),
                    PermissionId = table.Column<long>(type: "INTEGER", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_RolePermissions", x => new { x.RoleId, x.PermissionId });
                    table.ForeignKey(
                        name: "FK_RolePermissions_Permissions_PermissionId",
                        column: x => x.PermissionId,
                        principalTable: "Permissions",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_RolePermissions_Roles_RoleId",
                        column: x => x.RoleId,
                        principalTable: "Roles",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "BuyOrderReturns",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Code = table.Column<string>(type: "TEXT", nullable: false),
                    Name = table.Column<string>(type: "TEXT", nullable: false),
                    Remark = table.Column<string>(type: "TEXT", nullable: true),
                    CreatedAt = table.Column<DateTime>(type: "TEXT", nullable: false),
                    SupplierId = table.Column<long>(type: "INTEGER", nullable: false),
                    BuyOrderId = table.Column<long>(type: "INTEGER", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_BuyOrderReturns", x => x.Id);
                    table.ForeignKey(
                        name: "FK_BuyOrderReturns_Suppliers_SupplierId",
                        column: x => x.SupplierId,
                        principalTable: "Suppliers",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "BuyOrders",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Code = table.Column<string>(type: "TEXT", nullable: false),
                    Name = table.Column<string>(type: "TEXT", nullable: false),
                    SupplierId = table.Column<long>(type: "INTEGER", nullable: false),
                    Remark = table.Column<string>(type: "TEXT", nullable: true),
                    CreatedAt = table.Column<DateTime>(type: "TEXT", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_BuyOrders", x => x.Id);
                    table.ForeignKey(
                        name: "FK_BuyOrders_Suppliers_SupplierId",
                        column: x => x.SupplierId,
                        principalTable: "Suppliers",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "UserRoles",
                columns: table => new
                {
                    UserId = table.Column<long>(type: "INTEGER", nullable: false),
                    RoleId = table.Column<long>(type: "INTEGER", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_UserRoles", x => new { x.UserId, x.RoleId });
                    table.ForeignKey(
                        name: "FK_UserRoles_Roles_RoleId",
                        column: x => x.RoleId,
                        principalTable: "Roles",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_UserRoles_Users_UserId",
                        column: x => x.UserId,
                        principalTable: "Users",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "SaleOrderDetails",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    SaleOrderId = table.Column<long>(type: "INTEGER", nullable: false),
                    ProductId = table.Column<long>(type: "INTEGER", nullable: false),
                    Quantity = table.Column<int>(type: "INTEGER", nullable: false),
                    UnitPrice = table.Column<decimal>(type: "TEXT", nullable: false),
                    CreatedAt = table.Column<DateTime>(type: "TEXT", nullable: false),
                    Remark = table.Column<string>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_SaleOrderDetails", x => x.Id);
                    table.ForeignKey(
                        name: "FK_SaleOrderDetails_Products_ProductId",
                        column: x => x.ProductId,
                        principalTable: "Products",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_SaleOrderDetails_SaleOrders_SaleOrderId",
                        column: x => x.SaleOrderId,
                        principalTable: "SaleOrders",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "SaleOrderReturnDetails",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Quantity = table.Column<int>(type: "INTEGER", nullable: false),
                    UnitPrice = table.Column<decimal>(type: "TEXT", nullable: false),
                    CreatedAt = table.Column<DateTime>(type: "TEXT", nullable: false),
                    Remark = table.Column<string>(type: "TEXT", nullable: true),
                    SaleOrderReturnId = table.Column<long>(type: "INTEGER", nullable: false),
                    ProductId = table.Column<long>(type: "INTEGER", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_SaleOrderReturnDetails", x => x.Id);
                    table.ForeignKey(
                        name: "FK_SaleOrderReturnDetails_Products_ProductId",
                        column: x => x.ProductId,
                        principalTable: "Products",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_SaleOrderReturnDetails_SaleOrderReturns_SaleOrderReturnId",
                        column: x => x.SaleOrderReturnId,
                        principalTable: "SaleOrderReturns",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "BuyOrderReturnDetails",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Quantity = table.Column<int>(type: "INTEGER", nullable: false),
                    UnitPrice = table.Column<decimal>(type: "TEXT", nullable: false),
                    CreatedAt = table.Column<DateTime>(type: "TEXT", nullable: false),
                    Remark = table.Column<string>(type: "TEXT", nullable: true),
                    BuyOrderReturnId = table.Column<long>(type: "INTEGER", nullable: false),
                    ProductId = table.Column<long>(type: "INTEGER", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_BuyOrderReturnDetails", x => x.Id);
                    table.ForeignKey(
                        name: "FK_BuyOrderReturnDetails_BuyOrderReturns_BuyOrderReturnId",
                        column: x => x.BuyOrderReturnId,
                        principalTable: "BuyOrderReturns",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_BuyOrderReturnDetails_Products_ProductId",
                        column: x => x.ProductId,
                        principalTable: "Products",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "BuyOrderDetails",
                columns: table => new
                {
                    Id = table.Column<long>(type: "INTEGER", nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    BuyOrderId = table.Column<long>(type: "INTEGER", nullable: false),
                    ProductId = table.Column<long>(type: "INTEGER", nullable: false),
                    Quantity = table.Column<int>(type: "INTEGER", nullable: false),
                    UnitPrice = table.Column<decimal>(type: "TEXT", nullable: false),
                    CreatedAt = table.Column<DateTime>(type: "TEXT", nullable: false),
                    Remark = table.Column<string>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_BuyOrderDetails", x => x.Id);
                    table.ForeignKey(
                        name: "FK_BuyOrderDetails_BuyOrders_BuyOrderId",
                        column: x => x.BuyOrderId,
                        principalTable: "BuyOrders",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_BuyOrderDetails_Products_ProductId",
                        column: x => x.ProductId,
                        principalTable: "Products",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.InsertData(
                table: "Customers",
                columns: new[] { "Id", "Address", "Name", "Phone", "Remark" },
                values: new object[] { 1L, "北京市朝阳区", "张三", "13800000001", "VIP客户" });

            migrationBuilder.InsertData(
                table: "Customers",
                columns: new[] { "Id", "Address", "Name", "Phone", "Remark" },
                values: new object[] { 2L, "上海市浦东新区", "李四", "13800000002", "普通客户" });

            migrationBuilder.InsertData(
                table: "Customers",
                columns: new[] { "Id", "Address", "Name", "Phone", "Remark" },
                values: new object[] { 3L, "广州市天河区", "王五", "13800000003", "新客户" });

            migrationBuilder.InsertData(
                table: "Customers",
                columns: new[] { "Id", "Address", "Name", "Phone", "Remark" },
                values: new object[] { 4L, "深圳市南山区", "赵六", "13800000004", "" });

            migrationBuilder.InsertData(
                table: "Customers",
                columns: new[] { "Id", "Address", "Name", "Phone", "Remark" },
                values: new object[] { 5L, "杭州市西湖区", "钱七", "13800000005", "" });

            migrationBuilder.InsertData(
                table: "Customers",
                columns: new[] { "Id", "Address", "Name", "Phone", "Remark" },
                values: new object[] { 6L, "成都市武侯区", "孙八", "13800000006", "" });

            migrationBuilder.InsertData(
                table: "Customers",
                columns: new[] { "Id", "Address", "Name", "Phone", "Remark" },
                values: new object[] { 7L, "重庆市渝中区", "周九", "13800000007", "" });

            migrationBuilder.InsertData(
                table: "Customers",
                columns: new[] { "Id", "Address", "Name", "Phone", "Remark" },
                values: new object[] { 8L, "南京市鼓楼区", "吴十", "13800000008", "" });

            migrationBuilder.InsertData(
                table: "Customers",
                columns: new[] { "Id", "Address", "Name", "Phone", "Remark" },
                values: new object[] { 9L, "苏州市工业园区", "郑十一", "13800000009", "" });

            migrationBuilder.InsertData(
                table: "Customers",
                columns: new[] { "Id", "Address", "Name", "Phone", "Remark" },
                values: new object[] { 10L, "武汉市江汉区", "王十二", "13800000010", "" });

            migrationBuilder.InsertData(
                table: "Customers",
                columns: new[] { "Id", "Address", "Name", "Phone", "Remark" },
                values: new object[] { 11L, "天津市和平区", "冯十三", "13800000011", "" });

            migrationBuilder.InsertData(
                table: "Customers",
                columns: new[] { "Id", "Address", "Name", "Phone", "Remark" },
                values: new object[] { 12L, "青岛市市南区", "陈十四", "13800000012", "" });

            migrationBuilder.InsertData(
                table: "Customers",
                columns: new[] { "Id", "Address", "Name", "Phone", "Remark" },
                values: new object[] { 13L, "沈阳市和平区", "褚十五", "13800000013", "" });

            migrationBuilder.InsertData(
                table: "Customers",
                columns: new[] { "Id", "Address", "Name", "Phone", "Remark" },
                values: new object[] { 14L, "大连市中山区", "卫十六", "13800000014", "" });

            migrationBuilder.InsertData(
                table: "Customers",
                columns: new[] { "Id", "Address", "Name", "Phone", "Remark" },
                values: new object[] { 15L, "厦门市思明区", "蒋十七", "13800000015", "" });

            migrationBuilder.InsertData(
                table: "Customers",
                columns: new[] { "Id", "Address", "Name", "Phone", "Remark" },
                values: new object[] { 16L, "福州市鼓楼区", "沈十八", "13800000016", "" });

            migrationBuilder.InsertData(
                table: "Customers",
                columns: new[] { "Id", "Address", "Name", "Phone", "Remark" },
                values: new object[] { 17L, "济南市历下区", "韩十九", "13800000017", "" });

            migrationBuilder.InsertData(
                table: "Customers",
                columns: new[] { "Id", "Address", "Name", "Phone", "Remark" },
                values: new object[] { 18L, "合肥市庐阳区", "杨二十", "13800000018", "" });

            migrationBuilder.InsertData(
                table: "Customers",
                columns: new[] { "Id", "Address", "Name", "Phone", "Remark" },
                values: new object[] { 19L, "郑州市金水区", "朱二一", "13800000019", "" });

            migrationBuilder.InsertData(
                table: "Customers",
                columns: new[] { "Id", "Address", "Name", "Phone", "Remark" },
                values: new object[] { 20L, "长沙市芙蓉区", "秦二二", "13800000020", "" });

            migrationBuilder.InsertData(
                table: "Finance",
                columns: new[] { "Id", "Amount", "Code", "CreatedAt", "FormType", "Item", "Remark" },
                values: new object[] { 1L, 1200.00m, "F20230101", new DateTime(2023, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), 1, "销售收入", "销售商品收入" });

            migrationBuilder.InsertData(
                table: "Finance",
                columns: new[] { "Id", "Amount", "Code", "CreatedAt", "FormType", "Item", "Remark" },
                values: new object[] { 2L, -800.00m, "F20230102", new DateTime(2023, 1, 2, 0, 0, 0, 0, DateTimeKind.Unspecified), 2, "采购支出", "采购原材料" });

            migrationBuilder.InsertData(
                table: "Finance",
                columns: new[] { "Id", "Amount", "Code", "CreatedAt", "FormType", "Item", "Remark" },
                values: new object[] { 3L, -300.00m, "F20230103", new DateTime(2023, 1, 3, 0, 0, 0, 0, DateTimeKind.Unspecified), 1, "办公支出", "购买办公用品" });

            migrationBuilder.InsertData(
                table: "Finance",
                columns: new[] { "Id", "Amount", "Code", "CreatedAt", "FormType", "Item", "Remark" },
                values: new object[] { 4L, 1500.00m, "F20230104", new DateTime(2023, 1, 4, 0, 0, 0, 0, DateTimeKind.Unspecified), 2, "销售收入", "销售商品收入" });

            migrationBuilder.InsertData(
                table: "Finance",
                columns: new[] { "Id", "Amount", "Code", "CreatedAt", "FormType", "Item", "Remark" },
                values: new object[] { 5L, -400.00m, "F20230105", new DateTime(2023, 1, 5, 0, 0, 0, 0, DateTimeKind.Unspecified), 1, "运输支出", "物流运输费" });

            migrationBuilder.InsertData(
                table: "Finance",
                columns: new[] { "Id", "Amount", "Code", "CreatedAt", "FormType", "Item", "Remark" },
                values: new object[] { 6L, -2000.00m, "F20230106", new DateTime(2023, 1, 6, 0, 0, 0, 0, DateTimeKind.Unspecified), 2, "工资支出", "发放员工工资" });

            migrationBuilder.InsertData(
                table: "Finance",
                columns: new[] { "Id", "Amount", "Code", "CreatedAt", "FormType", "Item", "Remark" },
                values: new object[] { 7L, 1800.00m, "F20230107", new DateTime(2023, 1, 7, 0, 0, 0, 0, DateTimeKind.Unspecified), 1, "销售收入", "销售商品收入" });

            migrationBuilder.InsertData(
                table: "Finance",
                columns: new[] { "Id", "Amount", "Code", "CreatedAt", "FormType", "Item", "Remark" },
                values: new object[] { 8L, -900.00m, "F20230108", new DateTime(2023, 1, 8, 0, 0, 0, 0, DateTimeKind.Unspecified), 2, "采购支出", "采购原材料" });

            migrationBuilder.InsertData(
                table: "Finance",
                columns: new[] { "Id", "Amount", "Code", "CreatedAt", "FormType", "Item", "Remark" },
                values: new object[] { 9L, 600.00m, "F20230109", new DateTime(2023, 1, 9, 0, 0, 0, 0, DateTimeKind.Unspecified), 1, "利息收入", "银行存款利息" });

            migrationBuilder.InsertData(
                table: "Finance",
                columns: new[] { "Id", "Amount", "Code", "CreatedAt", "FormType", "Item", "Remark" },
                values: new object[] { 10L, -150.00m, "F20230110", new DateTime(2023, 1, 10, 0, 0, 0, 0, DateTimeKind.Unspecified), 2, "办公支出", "购买办公用品" });

            migrationBuilder.InsertData(
                table: "Finance",
                columns: new[] { "Id", "Amount", "Code", "CreatedAt", "FormType", "Item", "Remark" },
                values: new object[] { 11L, 2000.00m, "F20230201", new DateTime(2023, 2, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), 1, "销售收入", "销售商品收入" });

            migrationBuilder.InsertData(
                table: "Finance",
                columns: new[] { "Id", "Amount", "Code", "CreatedAt", "FormType", "Item", "Remark" },
                values: new object[] { 12L, -1200.00m, "F20230202", new DateTime(2023, 2, 2, 0, 0, 0, 0, DateTimeKind.Unspecified), 2, "采购支出", "采购原材料" });

            migrationBuilder.InsertData(
                table: "Finance",
                columns: new[] { "Id", "Amount", "Code", "CreatedAt", "FormType", "Item", "Remark" },
                values: new object[] { 13L, -350.00m, "F20230203", new DateTime(2023, 2, 3, 0, 0, 0, 0, DateTimeKind.Unspecified), 1, "办公支出", "购买办公用品" });

            migrationBuilder.InsertData(
                table: "Finance",
                columns: new[] { "Id", "Amount", "Code", "CreatedAt", "FormType", "Item", "Remark" },
                values: new object[] { 14L, 1700.00m, "F20230204", new DateTime(2023, 2, 4, 0, 0, 0, 0, DateTimeKind.Unspecified), 2, "销售收入", "销售商品收入" });

            migrationBuilder.InsertData(
                table: "Finance",
                columns: new[] { "Id", "Amount", "Code", "CreatedAt", "FormType", "Item", "Remark" },
                values: new object[] { 15L, -500.00m, "F20230205", new DateTime(2023, 2, 5, 0, 0, 0, 0, DateTimeKind.Unspecified), 1, "运输支出", "物流运输费" });

            migrationBuilder.InsertData(
                table: "Finance",
                columns: new[] { "Id", "Amount", "Code", "CreatedAt", "FormType", "Item", "Remark" },
                values: new object[] { 16L, -2100.00m, "F20230206", new DateTime(2023, 2, 6, 0, 0, 0, 0, DateTimeKind.Unspecified), 2, "工资支出", "发放员工工资" });

            migrationBuilder.InsertData(
                table: "Finance",
                columns: new[] { "Id", "Amount", "Code", "CreatedAt", "FormType", "Item", "Remark" },
                values: new object[] { 17L, 1600.00m, "F20230207", new DateTime(2023, 2, 7, 0, 0, 0, 0, DateTimeKind.Unspecified), 1, "销售收入", "销售商品收入" });

            migrationBuilder.InsertData(
                table: "Finance",
                columns: new[] { "Id", "Amount", "Code", "CreatedAt", "FormType", "Item", "Remark" },
                values: new object[] { 18L, -950.00m, "F20230208", new DateTime(2023, 2, 8, 0, 0, 0, 0, DateTimeKind.Unspecified), 2, "采购支出", "采购原材料" });

            migrationBuilder.InsertData(
                table: "Finance",
                columns: new[] { "Id", "Amount", "Code", "CreatedAt", "FormType", "Item", "Remark" },
                values: new object[] { 19L, 700.00m, "F20230209", new DateTime(2023, 2, 9, 0, 0, 0, 0, DateTimeKind.Unspecified), 1, "利息收入", "银行存款利息" });

            migrationBuilder.InsertData(
                table: "Finance",
                columns: new[] { "Id", "Amount", "Code", "CreatedAt", "FormType", "Item", "Remark" },
                values: new object[] { 20L, -180.00m, "F20230210", new DateTime(2023, 2, 10, 0, 0, 0, 0, DateTimeKind.Unspecified), 2, "办公支出", "购买办公用品" });

            migrationBuilder.InsertData(
                table: "Permissions",
                columns: new[] { "Id", "UniqueCode", "UniqueName" },
                values: new object[] { 1L, "User_View", "用户查看" });

            migrationBuilder.InsertData(
                table: "Permissions",
                columns: new[] { "Id", "UniqueCode", "UniqueName" },
                values: new object[] { 2L, "User_Edit", "用户编辑" });

            migrationBuilder.InsertData(
                table: "Permissions",
                columns: new[] { "Id", "UniqueCode", "UniqueName" },
                values: new object[] { 3L, "User_Delete", "用户删除" });

            migrationBuilder.InsertData(
                table: "Permissions",
                columns: new[] { "Id", "UniqueCode", "UniqueName" },
                values: new object[] { 4L, "Role_View", "角色查看" });

            migrationBuilder.InsertData(
                table: "Permissions",
                columns: new[] { "Id", "UniqueCode", "UniqueName" },
                values: new object[] { 5L, "Role_Edit", "角色编辑" });

            migrationBuilder.InsertData(
                table: "Permissions",
                columns: new[] { "Id", "UniqueCode", "UniqueName" },
                values: new object[] { 6L, "Role_Delete", "角色删除" });

            migrationBuilder.InsertData(
                table: "Permissions",
                columns: new[] { "Id", "UniqueCode", "UniqueName" },
                values: new object[] { 7L, "Permission_View", "权限查看" });

            migrationBuilder.InsertData(
                table: "Permissions",
                columns: new[] { "Id", "UniqueCode", "UniqueName" },
                values: new object[] { 8L, "Permission_Edit", "权限编辑" });

            migrationBuilder.InsertData(
                table: "Permissions",
                columns: new[] { "Id", "UniqueCode", "UniqueName" },
                values: new object[] { 9L, "Permission_Delete", "权限删除" });

            migrationBuilder.InsertData(
                table: "Permissions",
                columns: new[] { "Id", "UniqueCode", "UniqueName" },
                values: new object[] { 10L, "Product_View", "产品查看" });

            migrationBuilder.InsertData(
                table: "Permissions",
                columns: new[] { "Id", "UniqueCode", "UniqueName" },
                values: new object[] { 11L, "Product_Edit", "产品编辑" });

            migrationBuilder.InsertData(
                table: "Permissions",
                columns: new[] { "Id", "UniqueCode", "UniqueName" },
                values: new object[] { 12L, "Product_Delete", "产品删除" });

            migrationBuilder.InsertData(
                table: "Permissions",
                columns: new[] { "Id", "UniqueCode", "UniqueName" },
                values: new object[] { 13L, "Order_View", "订单查看" });

            migrationBuilder.InsertData(
                table: "Permissions",
                columns: new[] { "Id", "UniqueCode", "UniqueName" },
                values: new object[] { 14L, "Order_Edit", "订单编辑" });

            migrationBuilder.InsertData(
                table: "Permissions",
                columns: new[] { "Id", "UniqueCode", "UniqueName" },
                values: new object[] { 15L, "Order_Delete", "订单删除" });

            migrationBuilder.InsertData(
                table: "ProductCategorys",
                columns: new[] { "Id", "Code", "Name", "ParentId", "ProductCategoryId" },
                values: new object[] { 1L, "001", "全部", 0L, null });

            migrationBuilder.InsertData(
                table: "ProductCategorys",
                columns: new[] { "Id", "Code", "Name", "ParentId", "ProductCategoryId" },
                values: new object[] { 2L, "002", "电脑", 1L, null });

            migrationBuilder.InsertData(
                table: "ProductCategorys",
                columns: new[] { "Id", "Code", "Name", "ParentId", "ProductCategoryId" },
                values: new object[] { 3L, "003", "手机", 1L, null });

            migrationBuilder.InsertData(
                table: "Roles",
                columns: new[] { "Id", "Name", "Remark" },
                values: new object[] { 1L, "管理员", "系统管理员" });

            migrationBuilder.InsertData(
                table: "Roles",
                columns: new[] { "Id", "Name", "Remark" },
                values: new object[] { 2L, "销售员", "负责销售业务" });

            migrationBuilder.InsertData(
                table: "Roles",
                columns: new[] { "Id", "Name", "Remark" },
                values: new object[] { 3L, "采购员", "负责采购业务" });

            migrationBuilder.InsertData(
                table: "Roles",
                columns: new[] { "Id", "Name", "Remark" },
                values: new object[] { 4L, "仓库管理员", "负责仓库管理" });

            migrationBuilder.InsertData(
                table: "Roles",
                columns: new[] { "Id", "Name", "Remark" },
                values: new object[] { 5L, "财务", "负责财务管理" });

            migrationBuilder.InsertData(
                table: "Roles",
                columns: new[] { "Id", "Name", "Remark" },
                values: new object[] { 6L, "客服", "负责客户服务" });

            migrationBuilder.InsertData(
                table: "Roles",
                columns: new[] { "Id", "Name", "Remark" },
                values: new object[] { 7L, "运营", "负责运营管理" });

            migrationBuilder.InsertData(
                table: "Roles",
                columns: new[] { "Id", "Name", "Remark" },
                values: new object[] { 8L, "市场", "负责市场推广" });

            migrationBuilder.InsertData(
                table: "Roles",
                columns: new[] { "Id", "Name", "Remark" },
                values: new object[] { 9L, "技术支持", "负责技术支持" });

            migrationBuilder.InsertData(
                table: "Roles",
                columns: new[] { "Id", "Name", "Remark" },
                values: new object[] { 10L, "产品经理", "负责产品管理" });

            migrationBuilder.InsertData(
                table: "Roles",
                columns: new[] { "Id", "Name", "Remark" },
                values: new object[] { 11L, "测试", "负责系统测试" });

            migrationBuilder.InsertData(
                table: "Roles",
                columns: new[] { "Id", "Name", "Remark" },
                values: new object[] { 12L, "人事", "负责人力资源" });

            migrationBuilder.InsertData(
                table: "Roles",
                columns: new[] { "Id", "Name", "Remark" },
                values: new object[] { 13L, "审计", "负责审计工作" });

            migrationBuilder.InsertData(
                table: "Roles",
                columns: new[] { "Id", "Name", "Remark" },
                values: new object[] { 14L, "外部顾问", "外部专家顾问" });

            migrationBuilder.InsertData(
                table: "Roles",
                columns: new[] { "Id", "Name", "Remark" },
                values: new object[] { 15L, "访客", "只读权限" });

            migrationBuilder.InsertData(
                table: "Suppliers",
                columns: new[] { "Id", "Address", "Balance", "Name", "Phone", "Remark" },
                values: new object[] { 1L, "上海市黄浦区", 0m, "供应商一", "13900000001", "主营电子元件" });

            migrationBuilder.InsertData(
                table: "Suppliers",
                columns: new[] { "Id", "Address", "Balance", "Name", "Phone", "Remark" },
                values: new object[] { 2L, "北京市海淀区", 0m, "供应商二", "13900000002", "主营办公用品" });

            migrationBuilder.InsertData(
                table: "Suppliers",
                columns: new[] { "Id", "Address", "Balance", "Name", "Phone", "Remark" },
                values: new object[] { 3L, "深圳市南山区", 0m, "供应商三", "13900000003", "主营电脑配件" });

            migrationBuilder.InsertData(
                table: "Suppliers",
                columns: new[] { "Id", "Address", "Balance", "Name", "Phone", "Remark" },
                values: new object[] { 4L, "广州市天河区", 0m, "供应商四", "13900000004", "主营手机配件" });

            migrationBuilder.InsertData(
                table: "Suppliers",
                columns: new[] { "Id", "Address", "Balance", "Name", "Phone", "Remark" },
                values: new object[] { 5L, "杭州市西湖区", 0m, "供应商五", "13900000005", "主营办公家具" });

            migrationBuilder.InsertData(
                table: "Suppliers",
                columns: new[] { "Id", "Address", "Balance", "Name", "Phone", "Remark" },
                values: new object[] { 6L, "成都市武侯区", 0m, "供应商六", "13900000006", "主营网络设备" });

            migrationBuilder.InsertData(
                table: "Suppliers",
                columns: new[] { "Id", "Address", "Balance", "Name", "Phone", "Remark" },
                values: new object[] { 7L, "重庆市渝中区", 0m, "供应商七", "13900000007", "主营安防产品" });

            migrationBuilder.InsertData(
                table: "Suppliers",
                columns: new[] { "Id", "Address", "Balance", "Name", "Phone", "Remark" },
                values: new object[] { 8L, "南京市鼓楼区", 0m, "供应商八", "13900000008", "主营打印耗材" });

            migrationBuilder.InsertData(
                table: "Suppliers",
                columns: new[] { "Id", "Address", "Balance", "Name", "Phone", "Remark" },
                values: new object[] { 9L, "苏州市工业园区", 0m, "供应商九", "13900000009", "主营包装材料" });

            migrationBuilder.InsertData(
                table: "Suppliers",
                columns: new[] { "Id", "Address", "Balance", "Name", "Phone", "Remark" },
                values: new object[] { 10L, "武汉市江汉区", 0m, "供应商十", "13900000010", "主营办公设备" });

            migrationBuilder.InsertData(
                table: "Suppliers",
                columns: new[] { "Id", "Address", "Balance", "Name", "Phone", "Remark" },
                values: new object[] { 11L, "天津市和平区", 0m, "供应商十一", "13900000011", "主营照明设备" });

            migrationBuilder.InsertData(
                table: "Suppliers",
                columns: new[] { "Id", "Address", "Balance", "Name", "Phone", "Remark" },
                values: new object[] { 12L, "青岛市市南区", 0m, "供应商十二", "13900000012", "主营五金工具" });

            migrationBuilder.InsertData(
                table: "Suppliers",
                columns: new[] { "Id", "Address", "Balance", "Name", "Phone", "Remark" },
                values: new object[] { 13L, "沈阳市和平区", 0m, "供应商十三", "13900000013", "主营化工原料" });

            migrationBuilder.InsertData(
                table: "Suppliers",
                columns: new[] { "Id", "Address", "Balance", "Name", "Phone", "Remark" },
                values: new object[] { 14L, "大连市中山区", 0m, "供应商十四", "13900000014", "主营仪器仪表" });

            migrationBuilder.InsertData(
                table: "Suppliers",
                columns: new[] { "Id", "Address", "Balance", "Name", "Phone", "Remark" },
                values: new object[] { 15L, "厦门市思明区", 0m, "供应商十五", "13900000015", "主营食品原料" });

            migrationBuilder.InsertData(
                table: "Suppliers",
                columns: new[] { "Id", "Address", "Balance", "Name", "Phone", "Remark" },
                values: new object[] { 16L, "福州市鼓楼区", 0m, "供应商十六", "13900000016", "主营日用百货" });

            migrationBuilder.InsertData(
                table: "Suppliers",
                columns: new[] { "Id", "Address", "Balance", "Name", "Phone", "Remark" },
                values: new object[] { 17L, "济南市历下区", 0m, "供应商十七", "13900000017", "主营建材" });

            migrationBuilder.InsertData(
                table: "Suppliers",
                columns: new[] { "Id", "Address", "Balance", "Name", "Phone", "Remark" },
                values: new object[] { 18L, "合肥市庐阳区", 0m, "供应商十八", "13900000018", "主营家用电器" });

            migrationBuilder.InsertData(
                table: "Suppliers",
                columns: new[] { "Id", "Address", "Balance", "Name", "Phone", "Remark" },
                values: new object[] { 19L, "郑州市金水区", 0m, "供应商十九", "13900000019", "主营文体用品" });

            migrationBuilder.InsertData(
                table: "Suppliers",
                columns: new[] { "Id", "Address", "Balance", "Name", "Phone", "Remark" },
                values: new object[] { 20L, "长沙市芙蓉区", 0m, "供应商二十", "13900000020", "主营清洁用品" });

            migrationBuilder.InsertData(
                table: "Units",
                columns: new[] { "Id", "Name" },
                values: new object[] { 1L, "个" });

            migrationBuilder.InsertData(
                table: "Units",
                columns: new[] { "Id", "Name" },
                values: new object[] { 2L, "斤" });

            migrationBuilder.InsertData(
                table: "Units",
                columns: new[] { "Id", "Name" },
                values: new object[] { 3L, "米" });

            migrationBuilder.InsertData(
                table: "Units",
                columns: new[] { "Id", "Name" },
                values: new object[] { 4L, "卷" });

            migrationBuilder.InsertData(
                table: "Units",
                columns: new[] { "Id", "Name" },
                values: new object[] { 5L, "箱" });

            migrationBuilder.InsertData(
                table: "Units",
                columns: new[] { "Id", "Name" },
                values: new object[] { 6L, "包" });

            migrationBuilder.InsertData(
                table: "Units",
                columns: new[] { "Id", "Name" },
                values: new object[] { 7L, "台" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 1L, "admin", "宋江", "123456", "13800000001", "及时雨，水浒传首领，仗义疏财，号召力强。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 2L, "user01", "卢俊义", "123456", "13800000002", "玉麒麟，武艺高强，梁山第二把交椅。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 3L, "user02", "吴用", "123456", "13800000003", "智多星，足智多谋，梁山军师。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 4L, "user03", "公孙胜", "123456", "13800000004", "入云龙，道术高强，善使法术。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 5L, "user04", "关胜", "123456", "13800000005", "大刀，关羽后人，勇猛善战。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 6L, "user05", "林冲", "123456", "13800000006", "豹子头，八十万禁军教头，枪法高强。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 7L, "user06", "秦明", "123456", "13800000007", "霹雳火，勇猛刚烈，善使狼牙棒。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 8L, "user07", "呼延灼", "123456", "13800000008", "双鞭将，善使双鞭，原朝廷大将。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 9L, "user08", "花荣", "123456", "13800000009", "小李广，箭法如神，宋江挚友。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 10L, "user09", "柴进", "123456", "13800000010", "小旋风，豪门世家，仗义疏财。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 11L, "user10", "李应", "123456", "13800000011", "扑天雕，武艺高强，性格刚直。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 12L, "user11", "朱仝", "123456", "13800000012", "美髯公，忠厚仁义，善使长枪。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 13L, "user12", "鲁智深", "123456", "13800000013", "花和尚，力大无穷，性格豪爽。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 14L, "user13", "武松", "123456", "13800000014", "行者，打虎英雄，刚烈正直。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 15L, "user14", "董平", "123456", "13800000015", "双枪将，武艺高强，勇猛善战。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 16L, "qinshi_huang", "秦始皇", "123456", "13900000016", "中国第一个皇帝，统一六国，创立秦朝。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 17L, "liubang", "刘邦", "123456", "13900000017", "汉高祖，汉朝开国皇帝，推翻秦朝。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 18L, "liusheng", "刘彻", "123456", "13900000018", "汉武帝，开疆拓土，推行推恩令。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 19L, "caocao", "曹操", "123456", "13900000019", "三国时期魏国奠基人，政治家、军事家、诗人。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 20L, "liubei", "刘备", "123456", "13900000020", "三国时期蜀汉开国皇帝，仁德之主。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 21L, "sunquan", "孙权", "123456", "15000000021", "三国时期吴国开国皇帝，善于用人。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 22L, "zhugeliang", "诸葛亮", "123456", "15000000022", "三国时期蜀汉丞相，睿智多谋，鞠躬尽瘁。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 23L, "simayi", "司马懿", "123456", "15000000023", "三国时期魏国重臣，后晋朝奠基人。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 24L, "sunwu", "孙武", "123456", "15000000024", "春秋时期著名军事家，《孙子兵法》作者。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 25L, "wuzetian", "武则天", "123456", "15000000025", "中国历史上唯一的女皇帝，唐朝女皇。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 26L, "liubang", "刘邦", "123456", "15100000026", "汉高祖，汉朝开国皇帝。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 27L, "liubian", "刘备", "123456", "15100000027", "三国蜀汉开国皇帝。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 28L, "liusheng", "刘秀", "123456", "15100000028", "东汉开国皇帝，光武中兴。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 29L, "liyu", "李煜", "123456", "15100000029", "南唐后主，著名词人。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 30L, "yuefei", "岳飞", "123456", "15100000030", "南宋抗金名将，精忠报国。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 31L, "wen_tianxiang", "文天祥", "123456", "15200000031", "南宋末年民族英雄，正气歌作者。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 32L, "zhugeliang", "诸葛亮", "123456", "15200000032", "三国蜀汉丞相，睿智多谋。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 33L, "li_shimin", "李世民", "123456", "15200000033", "唐太宗，贞观之治缔造者。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 34L, "yangguifei", "杨贵妃", "123456", "15200000034", "唐玄宗宠妃，四大美女之一。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 35L, "bai_juyi", "白居易", "123456", "15200000035", "唐代大诗人，代表作《长恨歌》。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 36L, "dufu", "杜甫", "123456", "15500000036", "唐代伟大现实主义诗人，被称为诗圣" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 37L, "libai", "李白", "123456", "15500000037", "唐代浪漫主义诗人，被称为诗仙" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 38L, "wangwei", "王维", "123456", "15500000038", "唐代诗人、画家，诗佛。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 39L, "su_dongpo", "苏轼", "123456", "15500000039", "北宋文学家、书画家，号东坡居士。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 40L, "ouyangxiu", "欧阳修", "123456", "15500000040", "北宋文学家，唐宋八大家之一。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 41L, "simaqian", "司马迁", "123456", "15600000041", "西汉史学家，《史记》作者。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 42L, "zhugejin", "诸葛瑾", "123456", "15600000042", "三国东吴重臣，诸葛亮之兄。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 43L, "zhangfei", "张飞", "123456", "15600000043", "三国蜀汉名将，勇猛善战。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 44L, "guanyu", "关羽", "123456", "15600000044", "三国蜀汉名将，义薄云天。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 45L, "zhaoyun", "赵云", "123456", "15600000045", "三国蜀汉名将，常胜将军。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 46L, "machao", "马超", "123456", "15700000046", "三国蜀汉名将，西凉锦马超。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 47L, "huangzhong", "黄忠", "123456", "15700000047", "三国蜀汉老将，百步穿杨。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 48L, "sunce", "孙策", "123456", "15700000048", "三国东吴奠基人，小霸王。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 49L, "zhouyu", "周瑜", "123456", "15700000049", "三国东吴大都督，英俊潇洒。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 50L, "lu_sun", "陆逊", "123456", "15700000050", "三国东吴名将，火烧夷陵。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 51L, "lvbu", "吕布", "123456", "15800000051", "三国著名武将，勇冠三军。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 52L, "diaochan", "貂蝉", "123456", "15800000052", "三国时期美女，王允义女，四大美女之一。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 53L, "xunyu", "荀彧", "123456", "15800000053", "三国曹魏谋士，王佐之才。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 54L, "guojia", "郭嘉", "123456", "15800000054", "三国曹魏谋士，英年早逝。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 55L, "zhenji", "甄氏", "123456", "15800000055", "三国魏文帝曹丕皇后，才貌双全。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 56L, "liubei", "刘备", "123456", "15900000056", "三国蜀汉开国皇帝，仁德之主。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 57L, "zhangliao", "张辽", "123456", "15900000057", "三国曹魏名将，威震逍遥津。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 58L, "sunshangxiang", "孙尚香", "123456", "15900000058", "三国东吴公主，刘备之妻。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 59L, "liubei", "刘禅", "123456", "15900000059", "三国蜀汉后主，刘备之子。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 60L, "zhugedan", "诸葛诞", "123456", "15900000060", "三国曹魏名将，诸葛瑾之子。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 61L, "liqingzhao", "李清照", "123456", "16600000061", "宋代女词人，易安居士，婉约派代表。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 62L, "xin_qiji", "辛弃疾", "123456", "16600000062", "南宋豪放派词人，爱国志士。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 63L, "yuefei", "岳飞", "123456", "16600000063", "南宋抗金名将，精忠报国。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 64L, "hanxin", "韩信", "123456", "16600000064", "西汉开国名将，兵仙。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 65L, "zhangqian", "张骞", "123456", "16600000065", "西汉外交家，开辟丝绸之路。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 66L, "ban_chao", "班超", "123456", "17300000066", "东汉名将，经营西域。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 67L, "zhangheng", "张衡", "123456", "17300000067", "东汉科学家，发明地动仪。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 68L, "hua_tuo", "华佗", "123456", "17300000068", "东汉医学家，外科圣手。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 69L, "simaguang", "司马光", "123456", "17300000069", "北宋史学家，《资治通鉴》作者。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 70L, "zhuxi", "朱熹", "123456", "17300000070", "南宋理学家，理学集大成者。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 71L, "wangyangming", "王阳明", "123456", "17500000071", "明代思想家，心学创立者。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 72L, "zhenghe", "郑和", "123456", "17500000072", "明代航海家，七下西洋。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 73L, "li_shizhen", "李时珍", "123456", "17500000073", "明代医学家，《本草纲目》作者。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 74L, "xu_xiake", "徐霞客", "123456", "17500000074", "明代地理学家，旅行家。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 75L, "linzexu", "林则徐", "123456", "17500000075", "清代民族英雄，虎门销烟。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 76L, "zengguofan", "曾国藩", "123456", "17800000076", "清末重臣，湘军创立者。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 77L, "lihongzhang", "李鸿章", "123456", "17800000077", "清末洋务派代表，北洋大臣。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 78L, "zhangzizhong", "张自忠", "123456", "17800000078", "抗日名将，壮烈殉国。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 79L, "dengxiaoping", "邓小平", "123456", "17800000079", "中国改革开放总设计师。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 80L, "zhouenlai", "周恩来", "123456", "17800000080", "新中国开国总理，杰出外交家。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 81L, "sunzhongshan", "孙中山", "123456", "18800000081", "中国民主革命先行者，国父。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 82L, "liangqichao", "梁启超", "123456", "18800000082", "近代思想家，戊戌变法领袖。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 83L, "qiu_jin", "秋瑾", "123456", "18800000083", "近代女革命家，巾帼英雄。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 84L, "lu_xun", "鲁迅", "123456", "18800000084", "现代文学家，思想启蒙者。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 85L, "ba_jin", "巴金", "123456", "18800000085", "现代作家，《家》《春》《秋》作者。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 86L, "lao_she", "老舍", "123456", "19800000086", "现代作家，《骆驼祥子》作者。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 87L, "maozedong", "毛泽东", "123456", "19800000087", "中国共产党主要缔造者，伟大领袖。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 88L, "jiangjieshi", "蒋介石", "123456", "19800000088", "国民党领袖，近代历史人物。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 89L, "liangshuming", "梁漱溟", "123456", "19800000089", "现代哲学家，乡村建设运动倡导者。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 90L, "hu_shi", "胡适", "123456", "19800000090", "现代学者，新文化运动代表。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 91L, "chen_duxiu", "陈独秀", "123456", "19900000091", "新文化运动领袖，中共创始人之一。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 92L, "li_dazhao", "李大钊", "123456", "19900000092", "中国共产党创始人之一，革命先驱。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 93L, "zhangxueliang", "张学良", "123456", "19900000093", "东北少帅，西安事变主角。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 94L, "songqingling", "宋庆龄", "123456", "19900000094", "国母，孙中山夫人，国家领导人。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 95L, "songmeiling", "宋美龄", "123456", "19900000095", "蒋介石夫人，著名外交家。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 96L, "liangsid", "梁思成", "123456", "19900000096", "著名建筑学家，古建筑保护专家。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 97L, "qianxuesen", "钱学森", "123456", "19900000097", "中国航天之父，科学家。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 98L, "dengyingchao", "邓颖超", "123456", "19900000098", "妇女运动领袖，周恩来夫人。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 99L, "liangqichao", "梁启超", "123456", "19900000099", "近代思想家，戊戌变法领袖。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 100L, "zhangtaiyan", "章太炎", "123456", "19900000100", "近代思想家，国学大师。" });

            migrationBuilder.InsertData(
                table: "Users",
                columns: new[] { "Id", "Account", "Name", "Password", "Phone", "Remark" },
                values: new object[] { 101L, "admin", "章太炎", "123456", "19900000101", "近代思想家，国学大师。" });

            migrationBuilder.InsertData(
                table: "Products",
                columns: new[] { "Id", "Code", "Name", "Price", "ProductCategoryId", "Remark", "Unit" },
                values: new object[] { 1L, "PC001", "联想笔记本", 4500.00m, 2L, "高性能办公本", "台" });

            migrationBuilder.InsertData(
                table: "Products",
                columns: new[] { "Id", "Code", "Name", "Price", "ProductCategoryId", "Remark", "Unit" },
                values: new object[] { 2L, "PC002", "戴尔台式机", 3800.00m, 2L, "家用台式机", "台" });

            migrationBuilder.InsertData(
                table: "Products",
                columns: new[] { "Id", "Code", "Name", "Price", "ProductCategoryId", "Remark", "Unit" },
                values: new object[] { 3L, "PH001", "三星手机", 3200.00m, 3L, "畅销款", "个" });

            migrationBuilder.InsertData(
                table: "Products",
                columns: new[] { "Id", "Code", "Name", "Price", "ProductCategoryId", "Remark", "Unit" },
                values: new object[] { 4L, "PH002", "苹果手机", 6800.00m, 3L, "旗舰款", "个" });

            migrationBuilder.InsertData(
                table: "RolePermissions",
                columns: new[] { "PermissionId", "RoleId" },
                values: new object[] { 1L, 1L });

            migrationBuilder.InsertData(
                table: "RolePermissions",
                columns: new[] { "PermissionId", "RoleId" },
                values: new object[] { 2L, 2L });

            migrationBuilder.InsertData(
                table: "RolePermissions",
                columns: new[] { "PermissionId", "RoleId" },
                values: new object[] { 3L, 3L });

            migrationBuilder.InsertData(
                table: "RolePermissions",
                columns: new[] { "PermissionId", "RoleId" },
                values: new object[] { 4L, 4L });

            migrationBuilder.InsertData(
                table: "RolePermissions",
                columns: new[] { "PermissionId", "RoleId" },
                values: new object[] { 5L, 5L });

            migrationBuilder.InsertData(
                table: "RolePermissions",
                columns: new[] { "PermissionId", "RoleId" },
                values: new object[] { 6L, 6L });

            migrationBuilder.InsertData(
                table: "RolePermissions",
                columns: new[] { "PermissionId", "RoleId" },
                values: new object[] { 7L, 7L });

            migrationBuilder.InsertData(
                table: "RolePermissions",
                columns: new[] { "PermissionId", "RoleId" },
                values: new object[] { 8L, 8L });

            migrationBuilder.InsertData(
                table: "RolePermissions",
                columns: new[] { "PermissionId", "RoleId" },
                values: new object[] { 9L, 9L });

            migrationBuilder.InsertData(
                table: "RolePermissions",
                columns: new[] { "PermissionId", "RoleId" },
                values: new object[] { 10L, 10L });

            migrationBuilder.InsertData(
                table: "RolePermissions",
                columns: new[] { "PermissionId", "RoleId" },
                values: new object[] { 11L, 11L });

            migrationBuilder.InsertData(
                table: "RolePermissions",
                columns: new[] { "PermissionId", "RoleId" },
                values: new object[] { 12L, 12L });

            migrationBuilder.InsertData(
                table: "RolePermissions",
                columns: new[] { "PermissionId", "RoleId" },
                values: new object[] { 13L, 13L });

            migrationBuilder.InsertData(
                table: "RolePermissions",
                columns: new[] { "PermissionId", "RoleId" },
                values: new object[] { 14L, 14L });

            migrationBuilder.InsertData(
                table: "RolePermissions",
                columns: new[] { "PermissionId", "RoleId" },
                values: new object[] { 15L, 15L });

            migrationBuilder.InsertData(
                table: "UserRoles",
                columns: new[] { "RoleId", "UserId" },
                values: new object[] { 1L, 1L });

            migrationBuilder.InsertData(
                table: "UserRoles",
                columns: new[] { "RoleId", "UserId" },
                values: new object[] { 2L, 2L });

            migrationBuilder.InsertData(
                table: "UserRoles",
                columns: new[] { "RoleId", "UserId" },
                values: new object[] { 3L, 3L });

            migrationBuilder.InsertData(
                table: "UserRoles",
                columns: new[] { "RoleId", "UserId" },
                values: new object[] { 4L, 4L });

            migrationBuilder.InsertData(
                table: "UserRoles",
                columns: new[] { "RoleId", "UserId" },
                values: new object[] { 5L, 5L });

            migrationBuilder.InsertData(
                table: "UserRoles",
                columns: new[] { "RoleId", "UserId" },
                values: new object[] { 6L, 6L });

            migrationBuilder.InsertData(
                table: "UserRoles",
                columns: new[] { "RoleId", "UserId" },
                values: new object[] { 7L, 7L });

            migrationBuilder.InsertData(
                table: "UserRoles",
                columns: new[] { "RoleId", "UserId" },
                values: new object[] { 8L, 8L });

            migrationBuilder.InsertData(
                table: "UserRoles",
                columns: new[] { "RoleId", "UserId" },
                values: new object[] { 9L, 9L });

            migrationBuilder.InsertData(
                table: "UserRoles",
                columns: new[] { "RoleId", "UserId" },
                values: new object[] { 10L, 10L });

            migrationBuilder.InsertData(
                table: "UserRoles",
                columns: new[] { "RoleId", "UserId" },
                values: new object[] { 11L, 11L });

            migrationBuilder.InsertData(
                table: "UserRoles",
                columns: new[] { "RoleId", "UserId" },
                values: new object[] { 12L, 12L });

            migrationBuilder.InsertData(
                table: "UserRoles",
                columns: new[] { "RoleId", "UserId" },
                values: new object[] { 13L, 13L });

            migrationBuilder.InsertData(
                table: "UserRoles",
                columns: new[] { "RoleId", "UserId" },
                values: new object[] { 14L, 14L });

            migrationBuilder.InsertData(
                table: "UserRoles",
                columns: new[] { "RoleId", "UserId" },
                values: new object[] { 15L, 15L });

            migrationBuilder.CreateIndex(
                name: "IX_BuyOrderDetails_BuyOrderId",
                table: "BuyOrderDetails",
                column: "BuyOrderId");

            migrationBuilder.CreateIndex(
                name: "IX_BuyOrderDetails_ProductId",
                table: "BuyOrderDetails",
                column: "ProductId");

            migrationBuilder.CreateIndex(
                name: "IX_BuyOrderReturnDetails_BuyOrderReturnId",
                table: "BuyOrderReturnDetails",
                column: "BuyOrderReturnId");

            migrationBuilder.CreateIndex(
                name: "IX_BuyOrderReturnDetails_ProductId",
                table: "BuyOrderReturnDetails",
                column: "ProductId");

            migrationBuilder.CreateIndex(
                name: "IX_BuyOrderReturns_SupplierId",
                table: "BuyOrderReturns",
                column: "SupplierId");

            migrationBuilder.CreateIndex(
                name: "IX_BuyOrders_SupplierId",
                table: "BuyOrders",
                column: "SupplierId");

            migrationBuilder.CreateIndex(
                name: "IX_ProductCategorys_ProductCategoryId",
                table: "ProductCategorys",
                column: "ProductCategoryId");

            migrationBuilder.CreateIndex(
                name: "IX_Products_ProductCategoryId",
                table: "Products",
                column: "ProductCategoryId");

            migrationBuilder.CreateIndex(
                name: "IX_RolePermissions_PermissionId",
                table: "RolePermissions",
                column: "PermissionId");

            migrationBuilder.CreateIndex(
                name: "IX_SaleOrderDetails_ProductId",
                table: "SaleOrderDetails",
                column: "ProductId");

            migrationBuilder.CreateIndex(
                name: "IX_SaleOrderDetails_SaleOrderId",
                table: "SaleOrderDetails",
                column: "SaleOrderId");

            migrationBuilder.CreateIndex(
                name: "IX_SaleOrderReturnDetails_ProductId",
                table: "SaleOrderReturnDetails",
                column: "ProductId");

            migrationBuilder.CreateIndex(
                name: "IX_SaleOrderReturnDetails_SaleOrderReturnId",
                table: "SaleOrderReturnDetails",
                column: "SaleOrderReturnId");

            migrationBuilder.CreateIndex(
                name: "IX_SaleOrderReturns_CustomerId",
                table: "SaleOrderReturns",
                column: "CustomerId");

            migrationBuilder.CreateIndex(
                name: "IX_SaleOrders_CustomerId",
                table: "SaleOrders",
                column: "CustomerId");

            migrationBuilder.CreateIndex(
                name: "IX_UserRoles_RoleId",
                table: "UserRoles",
                column: "RoleId");
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropTable(
                name: "BuyOrderDetails");

            migrationBuilder.DropTable(
                name: "BuyOrderReturnDetails");

            migrationBuilder.DropTable(
                name: "Finance");

            migrationBuilder.DropTable(
                name: "RolePermissions");

            migrationBuilder.DropTable(
                name: "SaleOrderDetails");

            migrationBuilder.DropTable(
                name: "SaleOrderReturnDetails");

            migrationBuilder.DropTable(
                name: "Units");

            migrationBuilder.DropTable(
                name: "UserRoles");

            migrationBuilder.DropTable(
                name: "BuyOrders");

            migrationBuilder.DropTable(
                name: "BuyOrderReturns");

            migrationBuilder.DropTable(
                name: "Permissions");

            migrationBuilder.DropTable(
                name: "SaleOrders");

            migrationBuilder.DropTable(
                name: "Products");

            migrationBuilder.DropTable(
                name: "SaleOrderReturns");

            migrationBuilder.DropTable(
                name: "Roles");

            migrationBuilder.DropTable(
                name: "Users");

            migrationBuilder.DropTable(
                name: "Suppliers");

            migrationBuilder.DropTable(
                name: "ProductCategorys");

            migrationBuilder.DropTable(
                name: "Customers");
        }
    }
}
